package com.apiit.webserviceclient.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class MySQLiteHelper extends SQLiteOpenHelper {

  public static final String TABLE_AUTHENTICATION = "authentication";
  public static final String COLUMN_AUTHENTICATION_ID = "authentiation_id";
  public static final String COLUMN_AUTHENTICATION_NAME= "authentication_name";
  public static final String COLUMN_USER_NAME = "user_name";
  public static final String COLUMN_PASSWORD = "password";


  private static final String DATABASE_NAME = "apiit_bpel_client.db";
  private static final int DATABASE_VERSION = 5;

  // Database creation sql statement
  private static final String DATABASE_CREATE = "create table "
      + TABLE_AUTHENTICATION + "(" + COLUMN_AUTHENTICATION_ID
      + " integer primary key," + COLUMN_AUTHENTICATION_NAME
      + " text," + " text," + COLUMN_USER_NAME + " text," + COLUMN_PASSWORD + " text"+");";

  public MySQLiteHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase database) {
    database.execSQL(DATABASE_CREATE);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    Log.w(MySQLiteHelper.class.getName(),
        "Upgrading database from version " + oldVersion + " to "
            + newVersion + ", which will destroy all old data");
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_AUTHENTICATION);
    onCreate(db);
  }

} 